GrapeCity.CalcEngine.Functions Namespace > CalcAddressFunction Class > Evaluate Method : Evaluate(Object[]) Method |
The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].
Row_num is the row number to use in the cell reference.
Column_num is the column number to use in the cell reference.
[Abs_num] specifies the type of reference to return
[A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.
[Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.
'Declaration Public Overloads Overrides Function Evaluate( _ ByVal args() As System.Object _ ) As System.Object
'Usage Dim instance As CalcAddressFunction Dim args() As System.Object Dim value As System.Object value = instance.Evaluate(args)
public override System.object Evaluate( System.object[] args )
The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].
Row_num is the row number to use in the cell reference.
Column_num is the column number to use in the cell reference.
[Abs_num] specifies the type of reference to return
[A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.
[Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6